alter table jms_dm.dm_tab_interceptor_waybill_kafka_middle_hi
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_tab_interceptor_waybill_kafka_middle_hi;
create external table jms_dm.dm_tab_interceptor_waybill_kafka_middle_hi
(
    waybill_no             string comment '运单号',
    input_time             string comment '订单录入时间年月日时分秒',
    date_time              string comment '订单录入日期年月日',
    status                 int comment '--0失效 1生效',
    sys_time               string comment '系统时间',
    dispatch_network_code  string comment '派件网点',
    third_code             string comment '三段码',
    receiver_province_name string comment '收件省',
    receiver_city_name     string comment '收件市',
    receiver_area_name     string comment '收件区'
) COMMENT '疫情订单拦截推送给操作'
    PARTITIONED BY ( dt STRING COMMENT '小时')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_interceptor_waybill_kafka_middle_hi'
;